USE [MyCarat]
GO
/****** Object:  StoredProcedure [dbo].[sp_SaveUserBasic]    Script Date: 05/30/2012 18:26:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

if exists(select * from sysobjects where id=object_id('sp_ExistUserName) )
        drop proc sp_SaveUserBasic
GO


create  proc [dbo].[sp_ExistUserName]
  @name varchar(10)
  
as
  
  select 1 from UserBasic a where a.UserName=@name